CREATE TABLE [dbo].[JOL_Recruitment_Participants_apply]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[recruitment] [int] NULL,
[employing_unit] [int] NULL,
[booth_quantity] [int] NULL,
[booth_arrange] [nvarchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[remark_recruitment] [nvarchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[contactperson] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[is_payment] [bit] NULL,
[is_need_invoice] [bit] NULL,
[invoice_beginning] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[invoice_item] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[add_time] [smalldatetime] NULL,
[user_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[update_time] [smalldatetime] NULL,
[user_update] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[state] [bit] NULL,
[user_check] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[remark_invoice] [nvarchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[is_visible] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Recruitment_Participants_apply] ADD CONSTRAINT [PK_JOL_Recruitment_Participants_apply] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'展位安排', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'booth_arrange'
GO
EXEC sp_addextendedproperty N'MS_Description', N'展位数', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'booth_quantity'
GO
EXEC sp_addextendedproperty N'MS_Description', N'用人单位id', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'employing_unit'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发票开头', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'invoice_beginning'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发票项目', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'invoice_item'
GO
EXEC sp_addextendedproperty N'MS_Description', N'是否需要发票', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'is_need_invoice'
GO
EXEC sp_addextendedproperty N'MS_Description', N'是否已缴费', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'is_payment'
GO
EXEC sp_addextendedproperty N'MS_Description', N'岗位是否可见', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'is_visible'
GO
EXEC sp_addextendedproperty N'MS_Description', N'招聘会', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'recruitment'
GO
EXEC sp_addextendedproperty N'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'remark_invoice'
GO
EXEC sp_addextendedproperty N'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'remark_recruitment'
GO
EXEC sp_addextendedproperty N'MS_Description', N'审核状态', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'state'
GO
EXEC sp_addextendedproperty N'MS_Description', N'审核账户', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Participants_apply', 'COLUMN', N'user_check'
GO
